SELECT item.id, item.avatar, CONCAT( item.name, ' | ', item.brand) AS displayText,
            JSON_OBJECT('item.returned_qty', 0, 'item.purchase_vs_itemId', 0, 'item_id', item.id) AS otherField,
            JSON_OBJECT(
                'roi_star', item_behaivor.roi_star, 
                'speed_star', item_behaivor.speed_star, 
                'friction_star', item_behaivor.friction_star, 
                'perishable_star', item_behaivor.perishable_star
            ) AS behaivor
            FROM item 
            LEFT JOIN item_behaivor ON item_behaivor.item_id = item.id
            WHERE item.deleted = '0'  AND (name LIKE LOWER('%%') OR item.code LIKE LOWER('%%') ) 
            ORDER BY item.id LIMIT 10 ;